Qid Examcode Question Qimpath opt1 opt2 opt3 opt4 opt5 opt6 opt7 opt8 opt9 opt10 opt11 opt12 opt13 opt14 opt15 impath1 impath2 impath3 impath4 impath5 impath6 impath7 impath8 impath9 impath10 impath11 impath12 impath13 impath14 impath15 answers uanswer CR Edit Delete
75 1Z0-061 Which two statements are true regarding the count function? The count function can be used only for CHAR, VARCHAR2, and NUMBER data types. Count (*) returns the number of rows including duplicate rows and rows containing null value in any of the columns. Count (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column. Count (distinct inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column. A select statement using the COUNT function with a DISTINCT keyword cannot have a where clause. 2, 4 MC edit delete
74 1Z0-061 Which two statements are true regarding single row functions? MOD: returns the quotient of a division TRUNC: can be used with number and date values CONCAT: can be used to combine any number of values SYSDATE: returns the database server current date and time INSTR: can be used to find only the first occurrence of a character in a string TRIM: can be used to remove all the occurrences of a character from a string 2, 4 MC edit delete
73 1Z0-061 Which statement adds a column called salary to the employees table having 100 rows, 73-question.png Option A Option B Option C Option D 1 SC edit delete
72 1Z0-061 Which two statements are true regarding constraints? A foreign key cannot contain null values. A column with the unique constraint can contain null values. A constraint is enforced only for the insert operation on a table. A constraint can be disabled even if the constraint column contains data. All constraints can be defined at the column level as well as the table level. 2, 4 MC edit delete
71 1Z0-061 You issue the following command to alter the country column in the departments table 71-question.png It produces an error because column definitions cannot be altered to add default values. It executes successfully and all the rows that have a null value for the country column will be updated with the value 'USA'. It executes successfully. The modification to add the default value takes effect only from subsequent insertions to the table. It produces an error because the data type for the column is not specified. 2 SC edit delete
70 1Z0-061 You need to generate a list of all customer last names with their credit limits from the customers table. 70-question.png Option A Option B Option C Option D 2, 3 MC edit delete
69 1Z0-061 Examine the structure of the customers table: 69-question.png Self-join Subquery Full outer-join with self-join Left outer-join with self-join Right outer-join with self-join 1, 2 MC edit delete
68 1Z0-061 You need to display the first names of all customers from the customers table that contain the character 'e' and have the character 'a' in the second last position. 68-question.png Option A Option B Option C Option D 1 SC edit delete
67 1Z0-061 View the Exhibit and examine the data in the products table. 67-question.png It executes successfully but returns no result. It executes successfully and returns the required result. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid. It generates an error because the condition specified for the prod category column is not valid. 1 SC edit delete
66 1Z0-061 View the Exhibit and examine the structure of the CUSTOMERS table. 66-question.png Option A Option B Option C Option D 1 SC edit delete
65 1Z0-061 The customers table has the following structure: 65-question.png Option A Option B Option C Option D 2 SC edit delete
64 1Z0-061 View the Exhibits and examine the structures of the products and sales tables. 64-question.png Option A Option B Option C Option D 1, 3 MC edit delete
63 1Z0-061 Which statement is true regarding the default behavior of the order by clause? In a character sort, the values are case-sensitive. NULL values are not considered at all by the sort operation. Only those columns that are specified in the select list can be used in the order by clause. Numeric values are displayed from the maximum to the minimum value if they have decimal positions. 1 SC edit delete
62 1Z0-061 Examine the structure of the employees table: 62-question.png Option A Option B Option C Option D 4 SC edit delete
61 1Z0-061 Evaluate the following SQL statement: 61-question.png It produces an error. It executes but returns no rows. It generates output for null as well as the other values produced by the subquery. It ignores the null value and generates output for the other values produced by the subquery. 3 SC edit delete
60 1Z0-061 You issue the following command to drop the products table: SQL> DROP TABLE products; Which three statements are true about the implication of this command? All data along with the table structure is deleted. A pending transaction in the session is committed. All indexes on the table remain but they are invalidated. All views and synonyms remain but they are invalidated. All data in the table is deleted but the table structure remains. 1, 2, 4 MC edit delete
59 1Z0-061 Using the customers table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level. 59-question.png Option A Option B Option C Option D 3 SC edit delete
58 1Z0-061 Examine the structure of the employees table. 58-question.png Option A Option B Option C Option D 2, 4 MC edit delete
57 1Z0-061 View the Exhibit and examine the structure of the promotions table. 57-question.png WHERE promo_name NOT LIKE ‘T%’ AND promo_name NOT LIKE ‘N%’ AND promo_cost > 20000 AND promo_end_date > ‘1-JAN-01' 1 SC edit delete
56 1Z0-061 You want to display the date for the first Monday of the next month 56-question.png It executes successfully and returns the correct result. It executes successfully but does not return the correct result. It generates an error because TO_CHAR should be replaced with TO_DATE. It generates an error because rrrr should be replaced by rr in the format string. It generates an error because fm and double quotation marks should not be used in the format string. 1 SC edit delete
55 1Z0-061 Examine the data in the PROMO_BEGIN_DATE column of the promotions table: 55-question.png Option A Option B Option C Option D 1 SC edit delete
54 1Z0-061 View the Exhibit and examine the structure of the products table. 54-question.png It produces a syntax error. The result remains unchanged. The total price value would be lower than the correct value. The total price value would be higher than the correct value. 2 SC edit delete
53 1Z0-061 Examine the structure of the orders table: 53-question.png It executes successfully and gives the correct output. It gives an error because the TO_CHAR function is not valid. It executes successfully but does not give the correct output. It gives an error because the data type conversion in the SELECT list does not match the data type conversion in the GROUP BY clause. 4 SC edit delete
52 1Z0-061 In which three situations does a transaction complete? When a DELETE statement is executed When a ROLLBACK command is executed When a PL/SQL anonymous block is executed When a data definition language (DDL) statement is executed When a TRUNCATE statement is executed after the pending transaction 2, 4, 5 MC edit delete
51 1Z0-061 Which two statements are true regarding constraints? A table can have only one primary key and one foreign key. A table can have only one primary key but multiple foreign keys. Only the primary key can be defined at the column and table levels. The foreign key and parent table primary key must have the same name. Both primary key and foreign key constraints can be defined at both column and table levels. 2, 5 MC edit delete
50 1Z0-061 Which create table statement is valid? 50-question.png Option A Option B Option C Option D 4 SC edit delete
49 1Z0-061 You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by HIRE_DATE. 49-question.png Option A Option B Option C Option D 2 SC edit delete
48 1Z0-061 You want to display 5 percent of the rows from the sales table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows. Which query will provide the required result? 48-question.png Option A Option B Option C Option D 4 SC edit delete
47 1Z0-061 Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00, -1), -1)FROM DUAL; What would be the outcome? 16 100 160 200 150 3 SC edit delete
46 1Z0-061 Examine the data in the CUST_NAME column of the customers table. 46-question.png Option A Option B Option C Option D 2 SC edit delete
45 1Z0-061 You want to create a sales table with the following column specifications and data types: 45-question.png A B C D 45-Aans.png 45-Bans.png 45-Cans.png 45-Dans.png 4 SC edit delete
44 1Z0-061 Examine the create table statements for the stores and sales tables. 44-question.png Disable the primary key in the STORES table. Use CASCADE keyword with DELETE statement. DELETE the rows with STORE_ID = 900 from the SALES table and then delete rows from STORES table. Disable the FOREIGN KEY in SALES table and then delete the rows. Create the foreign key in the SALES table on SALES_ID column with on DELETE CASCADE option. 1, 3, 4 MC edit delete
43 1Z0-061 You issued the following command: SQL> DROP TABLE employees; Which three statements are true? All uncommitted transactions are committed. All indexes and constraints defined on the table being dropped are also dropped. Sequences used in the employees table become invalid. The space used by the employees table is reclaimed immediately. The employees table can be recovered using the rollback command. The employees table is moved to the recycle bin. 2, 3, 6 MC edit delete
42 1Z0-061 View the Exhibit and examine the structure of the products table. 42-question.png It produces an error. It shows the names of all products in the table. It shows the names of products whose list price is the second highest in the table. It shows the names of all products whose list price is less than the maximum list price. 3 SC edit delete
41 1Z0-061 View the Exhibits and examine the structures of the products, sales, and customers tables. 41-question.png Option A Option B Option C Option D 41-Aans.png 41-Bans.png 41-Cans.png 41-Dans.png 1, 3 MC edit delete
40 1Z0-061 View the Exhibit and examine the data in the costs table. 40-question.png It executes and produces the required result. It produces an error because an expression cannot be used in the order by clause. It produces an error because the DESC option cannot be used with an expression in the order by clause. It produces an error because the expression in the ORDER by clause should also be specified in the SELECT clause. 1 SC edit delete
39 1Z0-061 You need to produce a report where each customer's credit limit has been incremented by $1000. In the output, the customer's last name should have the heading Name and the incremented credit limit should be labeled New credit Limit. The column headings should have only the first letter of each word in uppercase. Which statement would accomplish this requirement? 39-question.png Option A Option B Option C Option D 3 SC edit delete
38 1Z0-061 Which two queries give the correct result? 38-question.png It executes successfully and gives the correct result. It executes successfully but does not give the correct result. It generates an error because a subquery cannot have a join condition in an update statement. It generates an error because multiple columns (SALARY, COMMISSION) cannot be specified together in an update statement. 2 SC edit delete
37 1Z0-061 View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns of the promotions table, and the required output format. 37-question.png A B C D 37-Aans.png 37-Bans.png 37-Cans.png 37-Dans.png 3, 4 MC edit delete
36 1Z0-061 Which statement is true regarding the UNION operator? By default, the output is not sorted. Null values are not ignored during duplicate checking. Names of all columns must be identical across all select statements. The number of columns selected in all select statements need not be the same. 4 SC edit delete
35 1Z0-061 Examine the structure of the products table: 35-question.png A B C D 35-Aans.png 35-Bans.png 35-Cans.png 35-Dans.png 1 SC edit delete
34 1Z0-061 Which two statements are true regarding subqueries? A subquery can retrieve zero or more rows. Only two subqueries can be placed at one level. A subquery can be used only in SQL query statements. A subquery can appear on either side of a comparison operator. There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement. 1, 4 MC edit delete
33 1Z0-061 Examine the structure of the sales table: 33-question.png The SALES1 table is created with no rows but only a structure. The SALES1 table would have primary key and unique constraints on the specified columns. The SALES1 table would not be created because of the invalid where clause. The SALES1 table would have not null and unique constraints on the specified columns. The SALES1 table would not be created because column-specified names in the select and create table clauses do not match, 1 SC edit delete
32 1Z0-061 You need to create a table with the following column specifications: 32-question.png A B C D 32-Aans.png 32-Bans.png 32-Cans.png 32-Dans.png 4 SC edit delete
31 1Z0-061 View the Exhibit and examine the data in the promotions table. 31-question.png A B C D 31-Aans.png 31-Bans.png 31-Cans.png 31-Dans.png 4 SC edit delete
30 1Z0-061 Examine the data in the ORD_ITEMS table: 30-question.png It gives an error because the having clause should be specified after the group by clause. It gives an error because all the aggregate functions used in the having clause must be specified in the select list. It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table. It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table. 3 SC edit delete
29 1Z0-061 YOU need to display the date ll-oct-2007 in words as ‘Eleventh of October, Two Thousand Seven'. Which SQL statement would give the required result? 29-question.png Option A Option B Option C Option D 1 SC edit delete
28 1Z0-061 View the Exhibit and examine the structure of the customers table. 28-question.png The values clause cannot be used in an INSERT with a subquery. Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match. The where clause cannot be used in a subquery embedded in an INSERT statement. The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table. 1 SC edit delete
27 1Z0-061 Examine the structure and data of the CUST_TRANS table: 27-question.png SELECT transdate +'10' FROM cust_trans; SELECT * FROM cust_trans WHERE transdate = '01-01-07'; SELECT transamt FROM cust_trans WHERE custno > "11"; SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07'; SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000; 1, 3, 4 MC edit delete
26 1Z0-061 View the Exhibit and examine the structure of the promotions table. 26-question.png It shows COST_REMARK for all the promos in the table. It produces an error because the SUBQUERY gives an error. It shows COST_REMARK for all the promos in the promo category 'TV' It produces an error because SUBQUERIES cannot be used with the case expression. 1 SC edit delete
25 1Z0-061 View the Exhibit and examine the structure of the customers table. 25-question.png Option A Option B Option C Option D 4 SC edit delete
24 1Z0-061 View the Exhibit and examine the structure of the SALES table. 24-question.png It executes successfully and generates the required result. It produces an error because count(*) should be specified in the SELECT clause also. It produces an error because count{*) should be only in the HAVING clause and not in the WHERE clause. It executes successfully but produces no result because COUNT (prod_id) should be used instead of COUNT (*). 3 SC edit delete
23 1Z0-061 Evaluate the following SQL commands: 23-question.png You cannot use SYSDATE in the condition of a check constraint. You cannot use the BETWEEN clause in the condition of a check constraint. You cannot use the NEXTVAL sequence value as a default value for a column. You cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD_NO is also the foreign key. 1, 3 MC edit delete
22 1Z0-061 Examine the data in the ename and hiredate columns of the employees table: 22-question.png It executes successfully and gives the correct output. It executes successfully but does not give the correct output. It generates an error because the REPLACE function is not valid. It generates an error because the SUBSTR function cannot be nested in the CONCAT function. 1 SC edit delete
21 1Z0-061 Examine the structure of the transactions table: 21-question.png Option A Option B Option C Option D 2 SC edit delete
20 1Z0-061 Evaluate the following query: 20-question.png It produces an error because flower braces have been used. It produces an error because the data types are not matching. It executes successfully and introduces an 's at the end of each PROMO_NAME in the output. It executes successfully and displays the literal "{'s start date was } * for each row in the output. 3 SC edit delete
19 1Z0-061 View the Exhibit and examine the data in the employees table: 19-question.png INNER JOIN FULL OUTER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN 3 SC edit delete
18 1Z0-061 View the Exhibit and examine the structure of the customers table. 18-question.png A B C D 18-Aans.png 18-Bans.png 18-Cans.png 18-Dans.png 3 SC edit delete
17 1Z0-061 You execute the following commands: 17-question.png None, because no input required Both the substitution variables 'hiredate' and 'mgr_id' Only 'hiredate' Only 'mgr_id' 2 SC edit delete
16 1Z0-061 Examine the types and examples of relationships that follow: 1. One-to-one a) Teacher to students 2. One-to-many b) Employees to Manager 3. Many-to-one c) Person to SSN 4. Many-to-many d) Customers to products Which option indicates the correctly matched relationships? 1-a, 2-b, 3-c, and 4-d 1-c, 2-d, 3-a, and 4-b 1-c, 2-a, 3-b, and 4-d 1-d, 2-b, 3-a, and 4-c 3 SC edit delete
15 1Z0-061 Which normal form is a table in if it has no multi-valued attributes and no partial dependencies? First normal form Second normal form Third normal form Fourth normal form 2 SC edit delete
14 1Z0-061 View the Exhibit and evaluate the structure and data in the CUST_STATUS table. 14-question.png It produces an error because the AMT_SPENT column contains a null value. It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT. It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or AMT_SPENT is null. It produces an error because the TO_NUMBER function must be used to convert the result of the NULLIF function before it can be used by the NVL2 function. 3 SC edit delete
13 1Z0-061 In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'. Evaluate the following query: 13-question.png Abigail PA Abigail Pa Abigail IS An error message 2 SC edit delete
12 1Z0-061 Which query will generate the required result? 12-question.png Option A Option B Option C Option D 4 SC edit delete
11 1Z0-061 Which three SQL statements would display the value 1890.55 as $1, 890.55? 11-question.png Option A Option B Option C Option D Option E 1, 4, 5 MC edit delete
10 1Z0-061 View the Exhibit and examine the description of SALES and PROMOTIONS tables. You want to delete rows from the sales table, where the PROMO_NAME column in the promotions table has either blowout sale of everyday low prices as values. Which three delete statements are valid? 10-question.png A B C D 10-Aans.png 10-Bans.png 10-Cans.png 10-Dans.png 2, 3, 4 MC edit delete
9 1Z0-061 Which three tasks can be performed using SQL functions built into Oracle Database? Displaying a date in a nondefault format Finding the number of characters in an expression Substituting a character string in a text expression with a specified string Combining more than two columns or expressions into a single column in the output 1, 2, 3 MC edit delete
8 1Z0-061 You need to create a table for a banking application. One of the columns in the table has the following requirements: 1) You want a column in the table to store the duration of the credit period. 2) The data in the column should be stored in a format such that it can be easily added and subtracted with date data type without using conversion functions. 3) The maximum period of the credit provision in the application is 30 days. 4) The interest has to be calculated for the number of days an individual has taken a credit for. Which data type would you use for such a column in the table? DATE NUMBER TIMESTAMP INTERVAL DAY TO SECOND INTERVAL YEAR TO MONTH 4 SC edit delete
7 1Z0-061 Examine the structure proposed for the transactions table: 7-question.png The CUST_STATUS column would give an error. The TRANS_VALIDITY column would give an error. The CUST_STATUS column would store exactly one character. The CUST_CREDIT_LIMIT column would not be able to store decimal values. The TRANS_VALIDITY column would have a maximum size of one character. The TRANS_DATE column would be able to store day, month, century, year, hour,minutes, seconds, and fractions of seconds 2, 3 MC edit delete
6 1Z0-061 View the Exhibit and examine the structure of the products table. 6-question.png The parenthesis should be added to enclose the entire expression. The double quotation marks should be removed from the column alias. The column alias should be replaced with the expression in the where clause. The column alias should be put in uppercase and enclosed within double quotation marks in the where clause. 3 SC edit delete
5 1Z0-061 You want to create a table employees in which the values of columns EMPLOYEES_ID and LOGIN_ID must be unique and not null. Which two SQL statements would create the required table? 5-question.png Option A Option B Option C Option D Option E Option F 4,5 MC edit delete
4 1Z0-061 View the Exhibits and examine products and sales tables. 4-question.png The statement executes successfully and produces the required output. The statement produces an error because item_cnt cannot be displayed in the outer query. The statement produces an error because a subquery in the from clause and outer-joins cannot be used together. The statement produces an error because the group by clause cannot be used in a subquery in the from clause. 1 SC edit delete
3 1Z0-061 View the Exhibit 3-question.png Only statement 1 executes successfully and gives the required result. Only statement 2 executes successfully and gives the required result. Both statements 1 and 2 execute successfully and give different results. Both statements 1 and 2 execute successfully and give the same required result. 4 SC edit delete
2 1Z0-061 View the Exhibit and examine the structure of the product, component, and PDT_COMP tables. In product table, PDTNO is the primary key. In component table, COMPNO is the primary key. In PDT_COMP table, SELECT pdtno, pdtname, compno, compname FROM product _____________ pdt_comp USING (pdtno) ____________ component USING (compno) WHERE compname IS NOT NULL; Which combination of joins used in the blanks in the above query gives the correct output? 2-question.png JOIN; JOIN FULL OUTER JOIN; FULL OUTER JOIN RIGHT OUTER JOIN; LEFT OUTER JOIN LEFT OUTER JOIN; RIGHT OUTER JOIN 3 SC edit delete
1 1Z0-061 Evaluate the Following SQL Statement: 1-question.png It executes successfully and displays rows in the descending order of PROMO_CATEGORY. It produces an error because positional notation cannot be used in the order by clause with set operators. It executes successfully but ignores the order by clause because it is not located at the end of the compound statement. It produces an error because the order by clause should appear only at the end of a compound query-that is, with the last select statement. 4 SC edit delete

Copyright © Designed & Developed by Sakthi Db Technology 2018